Define Report Schedules
Working with Report Scheduler
To work with report scheduler, select 11. Work with Report Scheduler from the Reporting, Scheduler etc. screen (STRJR > 12). The Work with Report Scheduler screen appears.
| Work with Report Scheduler Position to . . . . Subset by text . . . Type options, press Enter. 1=Select 2=Add 3=Copy 4=Delete 5=Run group Opt Group Seq Query AAAA victor test empty report 1.0 Display Application DSPAPJRN 2.0 Display Application DEMO1 3.0 Display Application MFAUS DAILY Run daily report group DAILYGU Daily, for GUI output (EXCEL like, preformatted) DAILYML Daily, in HTML, sent by Email HAIM TEST report groupe1 1.0 Display Application DEMO1 HATEST test report group 1.0 Display Application TEST4 2.0 Display Application DEMO1 3.0 Display Application MFAUS More... F3=Exit F5=Refresh F6=Add New Group F8=Print F12=Cancel |
1 = Select
An option to modify a group settings.
2 = Add
An option to add a report to a group.
3 = Copy
An option to copy a group.
4 = Delete
An option to delete a group .
5 = Run
An option to run a group.
To create a new report group, type F6. The Add Report Group screen appears. The following example has been filled in for a FRTNGHT Report Group name.
NOTE: We recommend a meaningful name like DAILY for daily reports, WEDNESD for report groups running every Wednesday, etc.
| Add Report Group Report groups are intended to run pre-defined sets of reports automatically on a periodic basis. If ZIP(*YES) is specified, all PDF, HTML, CSV will be sent together. Other individual reports parameters, if defined, override group parameters. The use of descriptive date values *YESTERDAY, *WEEKSTR... is recommended. Type choices, press Enter. Report Group name . . . FRTNGHT Name e.g. DAILY, WEEKLY, MONTHLY etc. Description . . . . . . Two Weeks Report_Example for User Guide Press Enter to continue to the Define Parameters screen. F3=Exit F12=Cancel |
Press Enter. The Define JR Report Group Details (DFNJRGRPD) screen appears.
| Define JR Report Group Details (DFNJRGRPD) Type choices, press Enter. Starting date and time: Starting date . . . . . . . . > *PRVWEEKS Date, *CURRENT, *YESTERDAY... Starting time . . . . . . . . 000000 Time Ending date and time: Ending date . . . . . . . . . *CURRENT Date, *CURRENT, *YESTERDAY... Ending time . . . . . . . . . 235959 Time User . . . . . . . . . . . . . . *ALL Name, generic*, *ALL Program name . . . . . . . . . . *ALL Name, generic*, *ALL Output . . . . . . . . . . . . . *PRINT *PRINT, *PDF, *HTML... Bottom F3=Exit F4=Prompt F5=Refresh F10=Additional parameters F12=Cancel F13=How to use this display F24=More keys |
Starting date and time
Define the start date and time. Press F4 to select predefined options.
*CURRENT = The current date (day the report runs)
*YESTERDAY = The day before the current date
*WEEKSTR = Beginning of the current week
*PRVWEEKSTR = Beginning of the previous week
*MONTHSTR = Beginning of the current month
*PRVMONTHSTR = Beginning of the previous month
*YEARSTR = Beginning of the current year
*PRVYEARSTR = Beginning of the previous year
*MON - *SUN = Day of the current (or previous) week
Ending date and time
Define the end date and time. Press F4 to select predefined options.
*CURRENT = The current date (day the report runs)
*YESTERDAY = The day before the current date
*WEEKSTR = Beginning of the current week
*PRVWEEKSTR = Beginning of the previous week
*MONTHSTR = Beginning of the current month
*PRVMONTHSTR = Beginning of the previous month
*YEARSTR = Beginning of the current year
*PRVYEARSTR = Beginning of the previous year
*MON - *SUN = Day of the current (or previous) week
User
Specify the user that should be covered by this report group.
Name = A specific user
Name* = A generic user
*ALL = All users
Program name
Specify the program names that should be covered by this report group.
Name = A specific program name
Name* = A generic program name
*ALL = All program names
Output
Select output format:
*HTML
*CSV
*OUTFILE
*PRINT1 - 9
Type choices and press Enter. The Add Job Schedule Entry (ADDJOBSCDE) screen appears.
| Add Job Schedule Entry (ADDJOBSCDE) Type choices, press Enter. Job name . . . . . . . . . . . . > JR@FRTNGHT Name, *JOBD Frequency . . . . . . . . . . . > *ONCE *ONCE, *WEEKLY, *MONTHLY Schedule date . . . . . . . . . > *NONE Date, *CURRENT, *MONTHSTR... Schedule day . . . . . . . . . . > *ALL *NONE, *ALL, *MON, *TUE... + for more values Schedule time . . . . . . . . . > 230000 Time, *CURRENT Additional Parameters Job description . . . . . . . . > *USRPRF Name, *USRPRF Library . . . . . . . . . . . Name, *LIBL, *CURLIB Bottom F3=Exit F4=Prompt F5=Refresh F10=Additional parameters F12=Cancel F13=How to use this display F24=More keys |
Press Enter. A new report group appears on the Work with Report Scheduler screen.
To add reports to the group, type 2 in the Opt field next to the group from the Work with Report Scheduler screen (STRJR > 12 > 11). The Add Report Definition screen appears.
| Add Report Definition Reports in a group run periodically, as per the group definition. If ZIP(*YES) is specified for the Group, the mail info is taken from the Group. All other parameters defined for a report, override group parameters. Group FRTNGHT Two Weeks Report_Example for User Guide Type choices, press Enter. Report Id. . . . . . . 1.0 Description . . . . . . Display Application Reporting command (F7). DSPAPJRN Command, *SELECT/F7=Select from list Display Application Report parameters (F4). F3=Exit F4=Set Parameters F7=Select Command F12=Cancel |
Report ID
Numeric ID automatically assigned by the AP-Journal
Description
Type in a meaningful description of your report.
Reporting command
Press F7 to select the available commands from a pop-up window.
NOTE: There are options to report from Receivers (DSPAPACRJ, DSPAPCRJ), from Containers (DSPAPJRN), or from single-file journals (DSPDBJRN).
Reporting parameters
Press F4 to select the report parameter. The Display Application Journal (DSPAPJRN) screen appears.
| Display Application Journal (DSPAPJRN) Type choices, press Enter. Application F4=Names SELECT Name, *SELECT, AUXXJ, DEMO1... Report F4=Names *NONE Name, *SELECT, *NONE, AUXXJ... Display last minutes . . . . . . *BYTIME Number, *BYTIME Starting date and time: Starting date . . . . . . . . *CURRENT Date, *CURRENT, *YESTERDAY... Starting time . . . . . . . . 000000 Time Ending date and time: Ending date . . . . . . . . . *CURRENT Date, *CURRENT, *YESTERDAY... Ending time . . . . . . . . . 235959 Time Analyze business data: Business item Id. . . . . . . *ALL 1-15, *ALL Test . . . . . . . . . . . . . EQ, NE, GT, GE, LT, LE... Value . . . . . . . . . . . . + for more values User profile . . . . . . . . . . *ALL Name, generic*, *ALL More... F3=Exit F4=Prompt F5=Refresh F10=Additional parameters F12=Cancel F13=How to use this display F24=More keys |
| Display Application Journal (DSPAPJRN) Type choices, press Enter. Program name . . . . . . . . . . *ALL Name, generic*, *ALL Library . . . . . . . . . . . *ALL Name, generic*, *ALL Journal entry types . . . . . . *ALL Character value, *ALL + for more values IPv4 (generic*) or IPv6 . . . . *ALL Prefix length for IPv6 . . . . . *ALL 1-128, *ALL Job name . . . . . . . . . . . . *ALL Name, generic*, *ALL User . . . . . . . . . . . . . *ALL Name, generic*, *ALL Number . . . . . . . . . . . . *ALL 000000-999999, *ALL Number of records to process . . *NOMAX Number, *NOMAX Output . . . . . . . . . . . . . * *, *PRINT, *PDF, *HTML.. Add column headings . . . . . . *YES *NO, *YES Output format . . . . . . . . . *STD *STD, *EXT, *LIST Display format . . . . . . . . . *LIST *LIST, *DETAIL More... F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys |
| Display Application Journal (DSPAPJRN) Type choices, press Enter. File to receive output . . . . . *AUTO Name, *AUTO Library . . . . . . . . . . . *DATE Name, *LIBL, *CURLIB, *DATE Replace or add records . . . . . *REPLACE *REPLACE, *ADD Include info only for file . . . *ALL Name, *ALL, *ALLHDR, *BYFLD Library (sets OUTFILE flds) . *LIBL Name, *LIBL Mail to (mail1,mail2,mail3..) . *NONE Mail text . . . . . . . . . . . + for more values Object size to allow attach . . 20 Size in MB, *NO, *NOMAX Delete if attached . . . . . . . *YES *NO, *YES Zip . . . . . . . . . . . . . . *NO *NO, *YES More... F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys |
| Display Application Journal (DSPAPJRN) Type choices, press Enter. ZIP password . . . . . . . . . Character value On missing data . . . . . . . . *INQ *CANCEL, *IGNORE, *LOAD, *INQ Additional Parameters Member . . . . . . . . . . . . . *ALL Name, generic*, *ALL Object (*TEMP for attach only) *AUTO Directory ('/dir/') . . . . . . *DATE More... F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys |
Type choices and press Enter to finish the definition and return to the Work with Report Scheduler screen.
Run Report Groups
To run a report group, type 6 in the Opt field next to the group from the Work with Report Scheduler screen (STRJR > 12 > 11). The Run Report Group (RUNRPTGRP) screen appears.
| Run Report Group (RUNRPTGRP) Type choices, press Enter. Product . . . . . . . . . . . . > JOURNAL FIREWALL, SCREEN, PASSWORD... Report group . . . . . . . . . . > FRTNGHT Name Job description . . . . . . . . > QBATCH Name, *NONE Library . . . . . . . . . . . > *PRODUCT Name, *PRODUCT, *LIBL... Bottom F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys |
Type choices and press Enter.
NOTE: Another way to access the Run Report Group (RUNRPTGRP) screen is STRJR > 12 > 12.